Exact Financials

 

Connectivity Manual - IFALL - Purchase receipts

Purchase receipts

As of version 3.23 it is possible to import receipts via EDIS. For this purpose tables have been added the the EDIS script for application EXACT. Those tables are LPERH for the receipt headers and LPERL for the receipt lines.

In the table below you see the fields that are available in those tables in application EXACT, including their data types and field lengths. If you would like to make use of these new fields you need to update your EDIS script, information on this can be found here.

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
	Header (LPERH)
1	ADM_NR	Integer	6	admdat	Company	Mandatory
2	RECEIPT_NUMBER	Integer	8	lperh	Receipt number	Default: first free number from setting
3	RECEIPT_STATUS	Integer	6	-	Status	Possible values: 31801 Entered (Default value for new receipts; only valed value for new receipts) 31805 Reentered (Value for updating existing receipts that were set back to author)
4	CREDITOR	Integer	8	credit	Creditor	Mandatory
5	SELECTION_CODE	Character	2	-	Selection code	-
6	REFERENCE	Character	30	-	Reference	-
7	REFERENCE_1	Character	30	-	Reference 1	-
8	REFERENCE_2	Character	30	-	Reference 2	-
9	REFERENCE_3	Character	30	-	Reference 3	-
10	EXTRA_DESCRIPTION_CODE	Character	2	lldesc	Extra description code	Default: from creditor
11	TEXT_CODE	Character	8	lltext	Text code	-
12	RECEIPT_DATE	Date	8	-	Receipt date	Default: current date
13	EXTERNAL_PACKINGSLIP_NUMBER	Character	10	-	External packing slip number	-
14	USERID_APPROVE	Character	12	euser	Approved by	When status that still needs approval, the field needs to be empty; otherwise default: userid of user currently logged in.
15	RECEIPT_ORIGIN	Integer	6	-	Origin	Default: 31901 (Unknown). You can use 31903, which will show up in reports as 'Import'.
16	EXTERNAL_SALES_ORDER_NUMBER	Character	8	-	External sales order number	-
17	DELIVERY_METHOD	Character	8	lldome	Delivery method	Default: from purchase setting
18	DELIVERY_ADDRESS	Character	8	admnac	Delivery address	Default: from purchase setting
19	NOTES	Character	1000	-	Notes	-
	Lines (LPERL)					-
1	ADM_NR	Integer	6	admdat	Company	-
2	RECEIPT_NUMBER	Integer	8	lperh	Receipt number	-
3	RECEIPT_LINE_NUMBER	Integer	4	lperl	Receipt line	Default: first free line number
4	ORDER_NUMBER	Integer	8	lpech	Purchase order number	Purchase order on which the receipt line is based
5	ORDER_LINE_NUMBER	Integer	4	lpecl	Purchase order line	Line number of the purchase order on which the receipt line is based
6	INVOICE_NUMBER	Integer	8	lpecih	Purchase invoice number	Purchase invoice on which the receipt line is based
7	INVOICE_LINE_NUMBER	Integer	4	lpecil	Purchase invoice line	Line number of the purchase invoice on which the receipt line is based
8	ITEM_CODE	Character	20	llitem	Item	If empty, the receipt line will be handled as a text line
9	EXTERNAL_ITEM_CODE	Character	20	-	External item code	Default: from the combination of the item and the extra description code (from the header)
10	DESCRIPTION	Character	40	-	Description	Default: - For item line, from the item - For text line, from the text line field
11	TEXTLINE	Character	1000	-	Text line	Text for text item or text line. For a text item, the text must match the given template; for other items, this field should be left empty.
12	ITEMGROUP_CODE	Character	8	lligrp	Item group	Only for text lines; for item lines the field should be left empty
13	QUANTITY_RECEIVED	Decimal	12	-	Quantity received	-
14	COST_CENTER	Character	8	ccent	Cost center	Default: from purchase setting
15	COST_UNIT	Character	8	cunit	Cost unit	Default from item group (for item line, the item group of the given item will be taken). If no cost unit available, then from purchase setting
16	MULTIDIM_CODE_1	Character	8	mdim1	Multi dimension 1	Default: from purchase setting
17	MULTIDIM_CODE_2	Character	8	mdim2	Multi dimension 2	Default: from purchase setting
18	MULTIDIM_CODE_3	Character	8	mdim3	Multi dimension 3	Default: from purchase setting
19	MULTIDIM_CODE_4	Character	8	mdim4	Multi dimension 4	Default: from purchase setting
20	MULTIDIM_CODE_5	Character	8	mdim5	Multi dimension 5	Default: from purchase setting
21	PROJECT_CODE	Character	10	prmst	Project	-
22	COST_CAT_CODE	Character	8	prccat	Cost category	If project field is filled, then this field is mandatory, otherwise it should be left empty
23	PROJECT_COST_CENTER	Character	8	ccent	Cost center	If project field is filled, then this field is mandatory and default filled from project master card or, if not available, from the receipt line cost center; otherwise it should be empty
24	PROJECT_DESCRIPTION	Character	30	-	Description	If project is filled, default is the receipt number with the reference; otherwise it should be empty
25	ASSET_CODE	Character	12	-	Asset	If filled, it should be a new asset. Note that when the asset quantity is greater than 1, the given asset code will be extended with numbers, indicating the separate assets, created for this receipt line
26	ASSET_SET	Character	8	fas_mast	Asset set	Mandatory if the asset code has been filled; otherwise it should be left empty
27	ASSET_QUANTITY	Decimal	12	-	Quantity	Mandatory if the asset code has been filled; otherwise it should be left empty. It indicates the number of assets that will be created.
28	ASSET_DESCRIPTION	Character	30	-	Description	If asset code is filled, default from receipt line description; otherwise it should be left empty
29	LOCATION_CODE	Character	8	fas_loc	Location	Default: from item; if no location available then from purchase setting

Note that when a purchase order or a purchase invoice has been filled, together with a line number, the defaults for all fields available in that purchase order or purchase invoice, will be taken from that entity.

---

Connectivity Manual > Contents > IFALL > Logistic > Purchase receipts

---

     

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security  level:	All - 0
Sub category:	Details	Document ID:	18.330.257
Assortment:	Exact Financials	Date:	03-12-2008
Release:		Attachment:
Disclaimer